Spring 2019 Course Syllabus
Course: ITSW-2334- Section: 01 Advanced Spreadsheets |
Instructor Information | |||||||||
---|---|---|---|---|---|---|---|---|---|
Instructor | Adriane Champagne | ||||||||
champagneam@lamarpa.edu | |||||||||
Phone | (409) 984-6416 | ||||||||
Office |
|
||||||||
Department |
|
||||||||
Course Information | |||||||||
Description | Advanced techniques for developing and modifying spreadsheets. Includes macros and data analysis functions. | ||||||||
Prerequisites |
Introduction to Spreadsheets, a computer applications course, or equivalent. |
||||||||
Learning Outcomes |
Outcomes 1. Identifies all main ideas, supporting details, and vocabulary in reading material; demonstrates a full understanding of the reading (PSLO ALPHA); measured by pre- and post-tests 2. Identifies terminology and concepts associated with spreadsheet applications (PSLO 2); measured by daily assignment 3. Create and design macros(PSLO 3); measured by daily assignment 4. Uses data analysis features(PSLO 3); measured by end-of-chapter assessment assignment 5. Develops solutions using linked worksheets (PSLO 2); measured by end of chapter assessment assignment. 7. Proofread and edit workbooks (PSLO 4); measured by application assignment |
||||||||
Core Objectives | |||||||||
Program Student Learning Outcomes |
PSLO ALPHA: Reading skills - Demonstrates comprehension of content-area reading material. PSLO 1. Demonstrates appropriate professionalism in the administrative workplace environment. SLO 1. Students will demonstrate appropriate professionalism in the administrative workplace environment PSLO 2. Uses current business administration skills. SLO 2. Students will use current business administration skills. PSLO 3. Uses current business office software applications. SLO 3. Students will use current business office software applications. PSLO 4. Proofreads and edits business documents. SLO 4. Students will proofread and edit business documents. |
||||||||
Textbooks |
NEW PERSPECTIVES Microsoft Office 365 EXCEL 2016 Comprehensive REQUIRED |By PARSONS EDITION: 17 PUBLISHER: CENGAGE L ISBN: 9781305880405 8 GB Flash drive Notebook to take notes. |
||||||||
Lecture Topics Outline |
Week Topic 1 Introduction to Course-Syllabus review, pre-test, Blackboard and Self Service Banner 2 Managing Your Files- Will need 8 GB flash drive and book. 3 Module 7 Developing an Excel Application 4 Module 8 Working with Advanced Functions 5 Case Problems Module 7 & 8 6 Review and Exam #1 7 Module 9 Exploring Financial Tools and Functions Spring Break 8 Module 10 Performing What-If-Analyses 9 Case Problems Module 9 and 10 10 Review and Exam #2 11 Module 11 Analyzing Data with Business Intelligence 12 Module 12 Collaborating on a Shared Workbook 13 Case Problems Module 11 and 12 14 Advanced Filters, Database Functions, and Summary IFS Functions 15 Review and Final Exam Schedule subject to change |
||||||||
Major Assignments Schedule |
Week Topic 1 Introduction to Course-Syllabus review, pre-test, Blackboard and Self Service Banner 2 Managing Your Files- Will need 8 GB flash drive and book. 3 Module 7 Developing an Excel Application 4 Module 8 Working with Advanced Functions 5 Case Problems Module 7 & 8 6 Review and Exam #1 7 Module 9 Exploring Financial Tools and Functions Spring Break 8 Module 10 Performing What-If-Analyses 9 Case Problems Module 9 and 10 10 Review and Exam #2 11 Module 11 Analyzing Data with Business Intelligence 12 Module 12 Collaborating on a Shared Workbook 13 Case Problems Module 11 and 12 14 Advanced Filters, Database Functions, and Summary IFS Functions 15 Review and Final Exam Schedule subject to change |
||||||||
Final Exam Date | May 10, 2019 - 11:00 AM Through May 10, 2019 - 1:30 PM | ||||||||
Grading Scale | 90 - 100=A 80 - 89=B 70 - 79=C 60 - 69=D Below 59 = F | ||||||||
Determination of Final Grade |
Assignments/ Quizzes 40%, Exams 60% | ||||||||
Course Policies | |||||||||
Instructor Policies |
I will not discuss your grades over the phone or by e-mail. If you want to discuss your grades, you must come to my office in person. Homework assignments will be given each week. Not all homework may be graded. LATE WORK is highly discouraged and will incur a 25 point penalty for every day it is late. Due dates are given and enough time is given to complete all work. NO EXCEPTIONS. Academic Policies: If you miss an exam, your lowest test grade will count twice. If you miss more than one exam, those exams will be given a grade of zero Students must leave the classroom after exam is finished. There will be a final exam. All students must take the exam on the scheduled date and time, and failure to do so will result in a 0 on the final exam. Every student MUST have a copy of the required textbooks by the second week of class. The student will still be responsible for any assignments given. Failure to have a text may result in being dropped from the class. No emailed work is accepted. Students are responsible for completing all assigned reading and video viewings. A failure to follow oral and/or written instructions will result in penalties. Academic dishonesty will result in a zero on any assignment; a second incidence of academic dishonesty will be handled based on campus policies and procedures with the department chair. Student IDs are required for the first exam. IDs must be visible on your desk before the exam is administered no ID, no exam. Students should keep a record of their grades/average. Instructor(s) will not average grades for students. Instructors do not drop grades. Software Requirements: If you are in a course that is using a specific software, you MUST have the software available to you either on your home computer or you must use the open lab provided in the Gates Library. Reliable Internet access is required for all online courses and many traditional courses. Computer failure and lack of internet access are not acceptable excuses for missed assignments, projects, quizzes, or exams. DO NOT wait until the last minute to complete class work or exams. Classroom Etiquette: The following behaviors will result in the student being asked during class time to cease the action and/or leave the classroom: using cell phones, talking, or keying while the instructor is giving instructions or during class discussions; leaving class early without informing the instructor; surfing the Internet during lecture; and displaying a rude or negative behavior toward the instructor or other students. No cell phones should be visible or heard during class. Again, you will be asked to leave the room for the remainder of the class. No blue tooth technology or recording of lectures in any format (unless approved by the instructor). No charging of cell phones in the classroom. E-Mail/Voice Mail Etiquette: Students must use appropriate e-mail etiquette when corresponding with instructor; for example, complete sentences and a full subject line with your name/course name. Voice mail messages should be clearly spoken identifying students name, course, and any return phone number. |
||||||||
Attendance Policy |
Poor attendance is a leading reason for termination from a job in all areas of employment. With this factor in mind, the instructor monitors student attendance daily. In addition, attendance on a regular basis is necessary for proper skill development. Quizzes will be given at the beginning of the class period. Students coming in to class late will not be allowed to take quizzes. A grade of zero will be recorded for the quiz. Assignments are due at the beginning of each class; student assignment coming in late will be assessed a penalty, even if the student arrives to class late and turns in work. Students are responsible for completing all assigned homework and for being prepared for each class meeting. This applies even if you were absent for the previous class meeting. |
||||||||
Academic Honesty | Academic honesty is expected from all students, and dishonesty in any form will not be tolerated. Please consult the LSC-PA policies (Section IX, subsection A, in the Faculty Handbook) for consequences of academic dishonesty. | ||||||||
Facility Policies |
|
||||||||
Important Information | |||||||||
ADA Considerations | The Americans with Disabilities Act (ADA) is a federal anti-discrimination statute that provides comprehensive civil rights for persons with disabilities. Among other things, this legislation requires that all students with disabilities be guaranteed a learning environment that provides for reasonable accommodation of their disabilities. If you believe you have a disability requiring an accommodation, please contact the the Office for Disability Services Coordinator, Room 231, in the Madison Monroe Building. The phone number is (409) 984-6241. | ||||||||
MyLamarPA | Be sure to check your campus E-mail and Course Homepage using MyLamarPA campus web portal (My.LamarPA.edu). When you've logged in, click the email icon in the upper right-hand corner to check email, or click on the "My Courses" tab to get to your Course Homepage. Click the link to your course and review the information presented. It is important that you check your email and Course Homepage regularly. You can also access your grades, transcripts, and determine who your academic advisor is by using MyLamarPA. | ||||||||
Other | |||||||||
HB 2504 | This syllabus is part of LSC-PA's efforts to comply with Texas House Bill 2504. |